Shared Paradox table
You can share Paradox tables in a Local area network using TSession component. Shared
tables can be located in a file server or any shared folder in a network. To share
a Paradox table do the following:
1. Make sure that Paradox table is located in a shared directory.
2. Read and Write permission must be enabled for this share.
3. Suppose that the share located in a computer named "server" and the share name
is "Info".
4. Drop a TSession component and a TTable.
5. At Session's NetFileDir write "\\server\Info"
6. At Session's SessionName write any name, for example: "sharing"
7. At Table's DatabaseName write: "\\server\Info"
8. At Table's SessionName select "sharing"
9. Select your shared table at Table's TableName property
11. Make sure that Execlusive is turned to False at Table component
Notes:
- Database name in all client computer must be the same, for example: \\ServerName\Share\Phones.
If you map it as a network drive instead of full network path, then you must select
the same drive letter in all client computers. If you are using path like this: 'd:\share'
in NetFileDir then don't use 'd:\share\'. All applications that share the same database
must use the typical NetFileDir string.
- Shared paradox tables is not a client server technique; it is a file sharing.
Each client uses it's own engine and load the entire table for any manipulation such
as reading and writing, so that it is not a good idea to use this technique in a
very big tables, slow connections or WANs.